package com.showtao.front.repository;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.showtao.front.domain.MobileOrder;
/**
 * 
 * @author Fanxin Zeng
 *
 */

public interface MobileOrderRepository extends JpaRepository<MobileOrder,Long>{

	@Query("select m from MobileOrder m where m.mobile= ?1 and m.createdAt >= ?2 and m.createdAt <= ?3")
	List<MobileOrder> findMobileOrderByMobileAndCreatedDate(String mobile, Date startDate, Date endDate);
}
